﻿namespace Admin.NET.Application.Service;

public class SqlQueryPrompt
{
    public string role { get; set; } // system / user

    public string content { get; set; }
}

public class SqlQueryOutput
{
    public string Sql { get; set; }

    public List<SqlQueryTableColumn> Columns { get; set; }

    public List<Dictionary<string, object>> Data { get; set; } // Dictionary<string, object>会被框架转成一个json对象，每个键值对就是一个属性，实现了动态对象
}


public class SqlQuerySqlInput
{
    public string Sql { get; set; }
}

// 前端Table组件的列配置
public class SqlQueryTableColumn
{
    public string key { get; set; } //列唯一值

    public string dataKey { get; set; } = ""; //列名

    public string title { get; set; } = ""; //列标题

    public int width { get; set; } = 150; //宽度, 必填

    public bool sortable = true;
}

// 调用智能体获取SQL的结果
public class SqlQueryGenerateResponse
{
    public string sql { get; set; } 

}